package com.fc.v2.model.auto;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import cn.hutool.core.util.StrUtil;

/**
 * 申请项目专家评分 ApplyScoreExample
 * @author Archie_自动生成
 * @date 2021-11-16 16:40:04
 */
public class ApplyScoreExample {

    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ApplyScoreExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }
        
				
        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }
        
				
        public Criteria andProjectIdIsNull() {
            addCriterion("project_id is null");
            return (Criteria) this;
        }

        public Criteria andProjectIdIsNotNull() {
            addCriterion("project_id is not null");
            return (Criteria) this;
        }

        public Criteria andProjectIdEqualTo(String value) {
            addCriterion("project_id =", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotEqualTo(String value) {
            addCriterion("project_id <>", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThan(String value) {
            addCriterion("project_id >", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThanOrEqualTo(String value) {
            addCriterion("project_id >=", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThan(String value) {
            addCriterion("project_id <", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThanOrEqualTo(String value) {
            addCriterion("project_id <=", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLike(String value) {
            addCriterion("project_id like", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotLike(String value) {
            addCriterion("project_id not like", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdIn(List<String> values) {
            addCriterion("project_id in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotIn(List<String> values) {
            addCriterion("project_id not in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdBetween(String value1, String value2) {
            addCriterion("project_id between", value1, value2, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotBetween(String value1, String value2) {
            addCriterion("project_id not between", value1, value2, "projectId");
            return (Criteria) this;
        }
        
				
        public Criteria andExpertIdIsNull() {
            addCriterion("expert_id is null");
            return (Criteria) this;
        }

        public Criteria andExpertIdIsNotNull() {
            addCriterion("expert_id is not null");
            return (Criteria) this;
        }

        public Criteria andExpertIdEqualTo(String value) {
            addCriterion("expert_id =", value, "expertId");
            return (Criteria) this;
        }

        public Criteria andExpertIdNotEqualTo(String value) {
            addCriterion("expert_id <>", value, "expertId");
            return (Criteria) this;
        }

        public Criteria andExpertIdGreaterThan(String value) {
            addCriterion("expert_id >", value, "expertId");
            return (Criteria) this;
        }

        public Criteria andExpertIdGreaterThanOrEqualTo(String value) {
            addCriterion("expert_id >=", value, "expertId");
            return (Criteria) this;
        }

        public Criteria andExpertIdLessThan(String value) {
            addCriterion("expert_id <", value, "expertId");
            return (Criteria) this;
        }

        public Criteria andExpertIdLessThanOrEqualTo(String value) {
            addCriterion("expert_id <=", value, "expertId");
            return (Criteria) this;
        }

        public Criteria andExpertIdLike(String value) {
            addCriterion("expert_id like", value, "expertId");
            return (Criteria) this;
        }

        public Criteria andExpertIdNotLike(String value) {
            addCriterion("expert_id not like", value, "expertId");
            return (Criteria) this;
        }

        public Criteria andExpertIdIn(List<String> values) {
            addCriterion("expert_id in", values, "expertId");
            return (Criteria) this;
        }

        public Criteria andExpertIdNotIn(List<String> values) {
            addCriterion("expert_id not in", values, "expertId");
            return (Criteria) this;
        }

        public Criteria andExpertIdBetween(String value1, String value2) {
            addCriterion("expert_id between", value1, value2, "expertId");
            return (Criteria) this;
        }

        public Criteria andExpertIdNotBetween(String value1, String value2) {
            addCriterion("expert_id not between", value1, value2, "expertId");
            return (Criteria) this;
        }
        
				
        public Criteria andScoreArgumentIsNull() {
            addCriterion("score_argument is null");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentIsNotNull() {
            addCriterion("score_argument is not null");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentEqualTo(Integer value) {
            addCriterion("score_argument =", value, "scoreArgument");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentNotEqualTo(Integer value) {
            addCriterion("score_argument <>", value, "scoreArgument");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentGreaterThan(Integer value) {
            addCriterion("score_argument >", value, "scoreArgument");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentGreaterThanOrEqualTo(Integer value) {
            addCriterion("score_argument >=", value, "scoreArgument");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentLessThan(Integer value) {
            addCriterion("score_argument <", value, "scoreArgument");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentLessThanOrEqualTo(Integer value) {
            addCriterion("score_argument <=", value, "scoreArgument");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentLike(Integer value) {
            addCriterion("score_argument like", value, "scoreArgument");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentNotLike(Integer value) {
            addCriterion("score_argument not like", value, "scoreArgument");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentIn(List<Integer> values) {
            addCriterion("score_argument in", values, "scoreArgument");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentNotIn(List<Integer> values) {
            addCriterion("score_argument not in", values, "scoreArgument");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentBetween(Integer value1, Integer value2) {
            addCriterion("score_argument between", value1, value2, "scoreArgument");
            return (Criteria) this;
        }

        public Criteria andScoreArgumentNotBetween(Integer value1, Integer value2) {
            addCriterion("score_argument not between", value1, value2, "scoreArgument");
            return (Criteria) this;
        }
        
				
        public Criteria andScoreBaseIsNull() {
            addCriterion("score_base is null");
            return (Criteria) this;
        }

        public Criteria andScoreBaseIsNotNull() {
            addCriterion("score_base is not null");
            return (Criteria) this;
        }

        public Criteria andScoreBaseEqualTo(Integer value) {
            addCriterion("score_base =", value, "scoreBase");
            return (Criteria) this;
        }

        public Criteria andScoreBaseNotEqualTo(Integer value) {
            addCriterion("score_base <>", value, "scoreBase");
            return (Criteria) this;
        }

        public Criteria andScoreBaseGreaterThan(Integer value) {
            addCriterion("score_base >", value, "scoreBase");
            return (Criteria) this;
        }

        public Criteria andScoreBaseGreaterThanOrEqualTo(Integer value) {
            addCriterion("score_base >=", value, "scoreBase");
            return (Criteria) this;
        }

        public Criteria andScoreBaseLessThan(Integer value) {
            addCriterion("score_base <", value, "scoreBase");
            return (Criteria) this;
        }

        public Criteria andScoreBaseLessThanOrEqualTo(Integer value) {
            addCriterion("score_base <=", value, "scoreBase");
            return (Criteria) this;
        }

        public Criteria andScoreBaseLike(Integer value) {
            addCriterion("score_base like", value, "scoreBase");
            return (Criteria) this;
        }

        public Criteria andScoreBaseNotLike(Integer value) {
            addCriterion("score_base not like", value, "scoreBase");
            return (Criteria) this;
        }

        public Criteria andScoreBaseIn(List<Integer> values) {
            addCriterion("score_base in", values, "scoreBase");
            return (Criteria) this;
        }

        public Criteria andScoreBaseNotIn(List<Integer> values) {
            addCriterion("score_base not in", values, "scoreBase");
            return (Criteria) this;
        }

        public Criteria andScoreBaseBetween(Integer value1, Integer value2) {
            addCriterion("score_base between", value1, value2, "scoreBase");
            return (Criteria) this;
        }

        public Criteria andScoreBaseNotBetween(Integer value1, Integer value2) {
            addCriterion("score_base not between", value1, value2, "scoreBase");
            return (Criteria) this;
        }
        
				
        public Criteria andScoreTeamIsNull() {
            addCriterion("score_team is null");
            return (Criteria) this;
        }

        public Criteria andScoreTeamIsNotNull() {
            addCriterion("score_team is not null");
            return (Criteria) this;
        }

        public Criteria andScoreTeamEqualTo(Integer value) {
            addCriterion("score_team =", value, "scoreTeam");
            return (Criteria) this;
        }

        public Criteria andScoreTeamNotEqualTo(Integer value) {
            addCriterion("score_team <>", value, "scoreTeam");
            return (Criteria) this;
        }

        public Criteria andScoreTeamGreaterThan(Integer value) {
            addCriterion("score_team >", value, "scoreTeam");
            return (Criteria) this;
        }

        public Criteria andScoreTeamGreaterThanOrEqualTo(Integer value) {
            addCriterion("score_team >=", value, "scoreTeam");
            return (Criteria) this;
        }

        public Criteria andScoreTeamLessThan(Integer value) {
            addCriterion("score_team <", value, "scoreTeam");
            return (Criteria) this;
        }

        public Criteria andScoreTeamLessThanOrEqualTo(Integer value) {
            addCriterion("score_team <=", value, "scoreTeam");
            return (Criteria) this;
        }

        public Criteria andScoreTeamLike(Integer value) {
            addCriterion("score_team like", value, "scoreTeam");
            return (Criteria) this;
        }

        public Criteria andScoreTeamNotLike(Integer value) {
            addCriterion("score_team not like", value, "scoreTeam");
            return (Criteria) this;
        }

        public Criteria andScoreTeamIn(List<Integer> values) {
            addCriterion("score_team in", values, "scoreTeam");
            return (Criteria) this;
        }

        public Criteria andScoreTeamNotIn(List<Integer> values) {
            addCriterion("score_team not in", values, "scoreTeam");
            return (Criteria) this;
        }

        public Criteria andScoreTeamBetween(Integer value1, Integer value2) {
            addCriterion("score_team between", value1, value2, "scoreTeam");
            return (Criteria) this;
        }

        public Criteria andScoreTeamNotBetween(Integer value1, Integer value2) {
            addCriterion("score_team not between", value1, value2, "scoreTeam");
            return (Criteria) this;
        }
        
				
        public Criteria andScoreShortlistIsNull() {
            addCriterion("score_shortlist is null");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistIsNotNull() {
            addCriterion("score_shortlist is not null");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistEqualTo(Integer value) {
            addCriterion("score_shortlist =", value, "scoreShortlist");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistNotEqualTo(Integer value) {
            addCriterion("score_shortlist <>", value, "scoreShortlist");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistGreaterThan(Integer value) {
            addCriterion("score_shortlist >", value, "scoreShortlist");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistGreaterThanOrEqualTo(Integer value) {
            addCriterion("score_shortlist >=", value, "scoreShortlist");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistLessThan(Integer value) {
            addCriterion("score_shortlist <", value, "scoreShortlist");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistLessThanOrEqualTo(Integer value) {
            addCriterion("score_shortlist <=", value, "scoreShortlist");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistLike(Integer value) {
            addCriterion("score_shortlist like", value, "scoreShortlist");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistNotLike(Integer value) {
            addCriterion("score_shortlist not like", value, "scoreShortlist");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistIn(List<Integer> values) {
            addCriterion("score_shortlist in", values, "scoreShortlist");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistNotIn(List<Integer> values) {
            addCriterion("score_shortlist not in", values, "scoreShortlist");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistBetween(Integer value1, Integer value2) {
            addCriterion("score_shortlist between", value1, value2, "scoreShortlist");
            return (Criteria) this;
        }

        public Criteria andScoreShortlistNotBetween(Integer value1, Integer value2) {
            addCriterion("score_shortlist not between", value1, value2, "scoreShortlist");
            return (Criteria) this;
        }
        
				
        public Criteria andAdviceContentIsNull() {
            addCriterion("advice_content is null");
            return (Criteria) this;
        }

        public Criteria andAdviceContentIsNotNull() {
            addCriterion("advice_content is not null");
            return (Criteria) this;
        }

        public Criteria andAdviceContentEqualTo(String value) {
            addCriterion("advice_content =", value, "adviceContent");
            return (Criteria) this;
        }

        public Criteria andAdviceContentNotEqualTo(String value) {
            addCriterion("advice_content <>", value, "adviceContent");
            return (Criteria) this;
        }

        public Criteria andAdviceContentGreaterThan(String value) {
            addCriterion("advice_content >", value, "adviceContent");
            return (Criteria) this;
        }

        public Criteria andAdviceContentGreaterThanOrEqualTo(String value) {
            addCriterion("advice_content >=", value, "adviceContent");
            return (Criteria) this;
        }

        public Criteria andAdviceContentLessThan(String value) {
            addCriterion("advice_content <", value, "adviceContent");
            return (Criteria) this;
        }

        public Criteria andAdviceContentLessThanOrEqualTo(String value) {
            addCriterion("advice_content <=", value, "adviceContent");
            return (Criteria) this;
        }

        public Criteria andAdviceContentLike(String value) {
            addCriterion("advice_content like", value, "adviceContent");
            return (Criteria) this;
        }

        public Criteria andAdviceContentNotLike(String value) {
            addCriterion("advice_content not like", value, "adviceContent");
            return (Criteria) this;
        }

        public Criteria andAdviceContentIn(List<String> values) {
            addCriterion("advice_content in", values, "adviceContent");
            return (Criteria) this;
        }

        public Criteria andAdviceContentNotIn(List<String> values) {
            addCriterion("advice_content not in", values, "adviceContent");
            return (Criteria) this;
        }

        public Criteria andAdviceContentBetween(String value1, String value2) {
            addCriterion("advice_content between", value1, value2, "adviceContent");
            return (Criteria) this;
        }

        public Criteria andAdviceContentNotBetween(String value1, String value2) {
            addCriterion("advice_content not between", value1, value2, "adviceContent");
            return (Criteria) this;
        }
        
				
        public Criteria andScoreTotalIsNull() {
            addCriterion("score_total is null");
            return (Criteria) this;
        }

        public Criteria andScoreTotalIsNotNull() {
            addCriterion("score_total is not null");
            return (Criteria) this;
        }

        public Criteria andScoreTotalEqualTo(Float value) {
            addCriterion("score_total =", value, "scoreTotal");
            return (Criteria) this;
        }

        public Criteria andScoreTotalNotEqualTo(Float value) {
            addCriterion("score_total <>", value, "scoreTotal");
            return (Criteria) this;
        }

        public Criteria andScoreTotalGreaterThan(Float value) {
            addCriterion("score_total >", value, "scoreTotal");
            return (Criteria) this;
        }

        public Criteria andScoreTotalGreaterThanOrEqualTo(Float value) {
            addCriterion("score_total >=", value, "scoreTotal");
            return (Criteria) this;
        }

        public Criteria andScoreTotalLessThan(Float value) {
            addCriterion("score_total <", value, "scoreTotal");
            return (Criteria) this;
        }

        public Criteria andScoreTotalLessThanOrEqualTo(Float value) {
            addCriterion("score_total <=", value, "scoreTotal");
            return (Criteria) this;
        }

        public Criteria andScoreTotalLike(Float value) {
            addCriterion("score_total like", value, "scoreTotal");
            return (Criteria) this;
        }

        public Criteria andScoreTotalNotLike(Float value) {
            addCriterion("score_total not like", value, "scoreTotal");
            return (Criteria) this;
        }

        public Criteria andScoreTotalIn(List<Float> values) {
            addCriterion("score_total in", values, "scoreTotal");
            return (Criteria) this;
        }

        public Criteria andScoreTotalNotIn(List<Float> values) {
            addCriterion("score_total not in", values, "scoreTotal");
            return (Criteria) this;
        }

        public Criteria andScoreTotalBetween(Float value1, Float value2) {
            addCriterion("score_total between", value1, value2, "scoreTotal");
            return (Criteria) this;
        }

        public Criteria andScoreTotalNotBetween(Float value1, Float value2) {
            addCriterion("score_total not between", value1, value2, "scoreTotal");
            return (Criteria) this;
        }
        
				
        public Criteria andOther2IsNull() {
            addCriterion("other2 is null");
            return (Criteria) this;
        }

        public Criteria andOther2IsNotNull() {
            addCriterion("other2 is not null");
            return (Criteria) this;
        }

        public Criteria andOther2EqualTo(String value) {
            addCriterion("other2 =", value, "other2");
            return (Criteria) this;
        }

        public Criteria andOther2NotEqualTo(String value) {
            addCriterion("other2 <>", value, "other2");
            return (Criteria) this;
        }

        public Criteria andOther2GreaterThan(String value) {
            addCriterion("other2 >", value, "other2");
            return (Criteria) this;
        }

        public Criteria andOther2GreaterThanOrEqualTo(String value) {
            addCriterion("other2 >=", value, "other2");
            return (Criteria) this;
        }

        public Criteria andOther2LessThan(String value) {
            addCriterion("other2 <", value, "other2");
            return (Criteria) this;
        }

        public Criteria andOther2LessThanOrEqualTo(String value) {
            addCriterion("other2 <=", value, "other2");
            return (Criteria) this;
        }

        public Criteria andOther2Like(String value) {
            addCriterion("other2 like", value, "other2");
            return (Criteria) this;
        }

        public Criteria andOther2NotLike(String value) {
            addCriterion("other2 not like", value, "other2");
            return (Criteria) this;
        }

        public Criteria andOther2In(List<String> values) {
            addCriterion("other2 in", values, "other2");
            return (Criteria) this;
        }

        public Criteria andOther2NotIn(List<String> values) {
            addCriterion("other2 not in", values, "other2");
            return (Criteria) this;
        }

        public Criteria andOther2Between(String value1, String value2) {
            addCriterion("other2 between", value1, value2, "other2");
            return (Criteria) this;
        }

        public Criteria andOther2NotBetween(String value1, String value2) {
            addCriterion("other2 not between", value1, value2, "other2");
            return (Criteria) this;
        }
        
			
		 public Criteria andLikeQuery(ApplyScore record) {
		 	List<String> list= new ArrayList<String>();
		 	List<String> list2= new ArrayList<String>();
        	StringBuffer buffer=new StringBuffer();
			if(record.getId()!=null&&StrUtil.isNotEmpty(record.getId().toString())) {
    			 list.add("ifnull(id,'')");
    		}
			if(record.getProjectId()!=null&&StrUtil.isNotEmpty(record.getProjectId().toString())) {
    			 list.add("ifnull(project_id,'')");
    		}
			if(record.getExpertId()!=null&&StrUtil.isNotEmpty(record.getExpertId().toString())) {
    			 list.add("ifnull(expert_id,'')");
    		}
			if(record.getScoreArgument()!=null&&StrUtil.isNotEmpty(record.getScoreArgument().toString())) {
    			 list.add("ifnull(score_argument,'')");
    		}
			if(record.getScoreBase()!=null&&StrUtil.isNotEmpty(record.getScoreBase().toString())) {
    			 list.add("ifnull(score_base,'')");
    		}
			if(record.getScoreTeam()!=null&&StrUtil.isNotEmpty(record.getScoreTeam().toString())) {
    			 list.add("ifnull(score_team,'')");
    		}
			if(record.getScoreShortlist()!=null&&StrUtil.isNotEmpty(record.getScoreShortlist().toString())) {
    			 list.add("ifnull(score_shortlist,'')");
    		}
			if(record.getAdviceContent()!=null&&StrUtil.isNotEmpty(record.getAdviceContent().toString())) {
    			 list.add("ifnull(advice_content,'')");
    		}
			if(record.getScoreTotal()!=null&&StrUtil.isNotEmpty(record.getScoreTotal().toString())) {
    			 list.add("ifnull(score_total,'')");
    		}
			if(record.getOther2()!=null&&StrUtil.isNotEmpty(record.getOther2().toString())) {
    			 list.add("ifnull(other2,'')");
    		}
			if(record.getId()!=null&&StrUtil.isNotEmpty(record.getId().toString())) {
    			list2.add("'%"+record.getId()+"%'");
    		}
			if(record.getProjectId()!=null&&StrUtil.isNotEmpty(record.getProjectId().toString())) {
    			list2.add("'%"+record.getProjectId()+"%'");
    		}
			if(record.getExpertId()!=null&&StrUtil.isNotEmpty(record.getExpertId().toString())) {
    			list2.add("'%"+record.getExpertId()+"%'");
    		}
			if(record.getScoreArgument()!=null&&StrUtil.isNotEmpty(record.getScoreArgument().toString())) {
    			list2.add("'%"+record.getScoreArgument()+"%'");
    		}
			if(record.getScoreBase()!=null&&StrUtil.isNotEmpty(record.getScoreBase().toString())) {
    			list2.add("'%"+record.getScoreBase()+"%'");
    		}
			if(record.getScoreTeam()!=null&&StrUtil.isNotEmpty(record.getScoreTeam().toString())) {
    			list2.add("'%"+record.getScoreTeam()+"%'");
    		}
			if(record.getScoreShortlist()!=null&&StrUtil.isNotEmpty(record.getScoreShortlist().toString())) {
    			list2.add("'%"+record.getScoreShortlist()+"%'");
    		}
			if(record.getAdviceContent()!=null&&StrUtil.isNotEmpty(record.getAdviceContent().toString())) {
    			list2.add("'%"+record.getAdviceContent()+"%'");
    		}
			if(record.getScoreTotal()!=null&&StrUtil.isNotEmpty(record.getScoreTotal().toString())) {
    			list2.add("'%"+record.getScoreTotal()+"%'");
    		}
			if(record.getOther2()!=null&&StrUtil.isNotEmpty(record.getOther2().toString())) {
    			list2.add("'%"+record.getOther2()+"%'");
    		}
        	buffer.append(" CONCAT(");
	        buffer.append(StrUtil.join(",",list));
        	buffer.append(")");
        	buffer.append(" like CONCAT(");
        	buffer.append(StrUtil.join(",",list2));
        	buffer.append(")");
        	if(!" CONCAT() like CONCAT()".equals(buffer.toString())) {
        		addCriterion(buffer.toString());
        	}
        	return (Criteria) this;
        }
        
        public Criteria andLikeQuery2(String searchText) {
		 	List<String> list= new ArrayList<String>();
        	StringBuffer buffer=new StringBuffer();
    		list.add("ifnull(id,'')");
    		list.add("ifnull(project_id,'')");
    		list.add("ifnull(expert_id,'')");
    		list.add("ifnull(score_argument,'')");
    		list.add("ifnull(score_base,'')");
    		list.add("ifnull(score_team,'')");
    		list.add("ifnull(score_shortlist,'')");
    		list.add("ifnull(advice_content,'')");
    		list.add("ifnull(score_total,'')");
    		list.add("ifnull(other2,'')");
        	buffer.append(" CONCAT(");
	        buffer.append(StrUtil.join(",",list));
        	buffer.append(")");
        	buffer.append("like '%");
        	buffer.append(searchText);
        	buffer.append("%'");
        	addCriterion(buffer.toString());
        	return (Criteria) this;
        }
        
}
	
    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}